Workspace vs. Local environment

Using the Classroom Workspace vs. Setting up your local environment

We have provided two ways for you to work on the SQL database.

Option 1:

We have set up the DVD Rental database within the Classroom Workspace to allow you to run your queries on the database. We ** encourage you to use the Workspace within your classroom**. _ If you are short on time, and don't have at least a couple of hours available to set up the database, we strongly recommend using the Workspace within your classroom._ If you prefer to use the classroom workspace, jump ahead to the concept titled ** "Composite Key".**

Option 2:

Alternately, you can run the queries on your local machine using a new database system, PostgreSQL. Please keep in mind - ** this option requires setting aside at least a couple of hours to set up the PostgreSQL database. Also, you may find learning to set up a PostgreSQL database on your local machine involves a sharp learning curve.** Learning how to set up and use PostgreSQL is a valuable skill to add to your data analyst skill set, so the time you spend on it will be worth it.

If you choose Option 2, you will have two additional tasks to complete:

a) You will need to install the new database system, PostgreSQL.

b) You will need to load the database in your local PostgreSQL database server.

What is PostgreSQL?

PostgreSQL is an open-source object-relational database system that is used frequently in industry (and that is running in the background of the SQL queries you have been running in the classroom). At some point, you may find yourself learning how to use this platform and running the application locally on your machine. However, learning to use and manage the PostgreSQL applications is in itself a challenge. If you decide to use the PostgreSQL platform, we strongly advise that you set aside some time for getting familiar with the environment before beginning this project. You will find this step well worth the effort!

We encourage you to use the Classroom Workspaces if PostgreSQL installation and setting up the database is taking too much time.

Either Option 1 or Option 2 can be used to complete and pass the project! You do not need to do both.

Next Concept